package com.baturu.vin.benz.dal.dao;

import com.baturu.vin.benz.dto.BenzSaDTO;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * @Author: jiangxinlei
 * @Time: 2018-05-21 11:20
 **/
public interface BenzSaDAO {

    @Select({"select distinct class as classNo, sacode, type, a_date as adate, a_desc as adesc from sa_codes2_v",
            "where contain_keyword =1"})
    List<BenzSaDTO> queryAllSaDescription();

    @Select({"select distinct saCode, translation from benz_feature_mapping"})
    List<Map<String,String>> queryAllFeaturesMapping();

}
